package com.example.tool.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.tool.bean.business.MojiCityDO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface MojiCityMapper extends BaseMapper<MojiCityDO> {

    /**
     * 所有中国城市获取
     * @return 所有中国城市
     */
    @Select("SELECT * FROM moji_city WHERE country_en = 'China' and city_type = 0 and city_ch = leader_ch")
    List<MojiCityDO> getAllChinaCity();
}
